[dbo].[asi_GroupTypeMembershipByContact]
CREATE PROCEDURE [dbo].[asi_GroupTypeMembershipByContact] (@contactKey uniqueidentifier)
AS
BEGIN
SELECT DISTINCT GroupMain.GroupTypeKey, GroupTypeRef.GroupTypeName
FROM GroupMember INNER JOIN
GroupMain ON GroupMember.GroupKey = GroupMain.GroupKey INNER JOIN
GroupTypeRef ON GroupMain.GroupTypeKey = GroupTypeRef.GroupTypeKey
WHERE (GroupMember.MemberContactKey = @contactKey)
ORDER BY GroupTypeRef.GroupTypeName
END
GO
